# coding: utf-8
from flask_sqlalchemy import SQLAlchemy


db = SQLAlchemy()



class UserInfo(db.Model):
    __tablename__ = 'userInfo'

    AutoID = db.Column(db.BigInteger, primary_key=True, info='主键')
    userID = db.Column(db.BigInteger, nullable=False, index=True, info='用户ID')
    username = db.Column(db.String(20), info='用户名')
    account = db.Column(db.String(255), info='账号')
    password = db.Column(db.String(255), info='密码')
    isDelete = db.Column(db.Integer, server_default=db.FetchedValue(), info='用户是否被注销')
    createTime = db.Column(db.DateTime, server_default=db.FetchedValue(), info='用户注册时间')
